create procedure [dbo].[BAEOrderProductCategoryLookupInsert] @OrderProductID as
int,
    @OrderCategoryID AS int,
    @IsFeatured AS bit,
    @SortOrder AS int
AS
    INSERT INTO OrderProductCategoryLookup
    (    
    OrderProductID,            
    OrderCategoryID,            
    IsFeatured,                
    SortOrder        
    )
    VALUES
    (    
    @OrderProductID,            
    @OrderCategoryID,            
    @IsFeatured,                
    @SortOrder
    );

GO